set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

--CREATEd:02/08/2010
--Author: nnamthach@gmail.com
Create procedure [dbo].[procLookups_getAllByCategory](
@Category as nvarchar(20)
)
AS
BEGIN 
SELECT
	Category,
	Code,
	Description,
	Description1,
	Altermate,
	Status,
	CREATEDBY,
	MODIFIEDBY,
	CREATEDDATE,
	MODIFIEDDATE
	
FROM  dbo.[Lookups]
WHERE 	(
		@Category = Category
)
END

